CREATE TABLE [dbo].[ContactFundraising]
(
[ContactKey] [uniqueidentifier] NOT NULL,
[SoftCreditGroupKey] [uniqueidentifier] NULL,
[SolicitorGroupKey] [uniqueidentifier] NULL,
[ReceiptPreferenceCode] [int] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ContactFundraising] ADD CONSTRAINT [PK_ContactFundraising] PRIMARY KEY CLUSTERED ([ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContactFundraising_ReceiptPreferenceCode] ON [dbo].[ContactFundraising] ([ReceiptPreferenceCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContactFundraising_SoftCreditGroupKey] ON [dbo].[ContactFundraising] ([SoftCreditGroupKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContactFundraising_SolicitorGroupKey] ON [dbo].[ContactFundraising] ([SolicitorGroupKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContactFundraising] ADD CONSTRAINT [FK_ContactFundRaising_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO
ALTER TABLE [dbo].[ContactFundraising] ADD CONSTRAINT [FK_ContactFundraising_FundraisingPreferenceRef_Receipt] FOREIGN KEY ([ReceiptPreferenceCode]) REFERENCES [dbo].[FundraisingPreferenceRef] ([FundraisingPreferenceCode])
GO
ALTER TABLE [dbo].[ContactFundraising] ADD CONSTRAINT [FK_ContactFundRaising_GroupMain_SoftCredit] FOREIGN KEY ([SoftCreditGroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO
ALTER TABLE [dbo].[ContactFundraising] ADD CONSTRAINT [FK_ContactFundRaising_GroupMain_Solicitor] FOREIGN KEY ([SolicitorGroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO